<!doctype html>
<html><head>
<meta charset="utf-8">
<title>亿欧关键词工具</title>
<style type="text/css">
span{
	color:red;
}
</style>
<body>
<span>
<?php
//if ($_FILES["file"]["type"] == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"){
    if ($_FILES["file"]["error"] > 0){
        echo "Error: " . $_FILES["file"]["error"] . "<br />";
    }else{
        move_uploaded_file($_FILES["file"]["tmp_name"],"upload/".$_FILES["file"]["name"]); 
		echo $_FILES["file"]["name"];    
    }
/*}
else{
    echo "无效文件！";
}*/

require('inc/MYSQL_Connection.php');
if(mysqli_connect_errno()){
    echo "数据库连接失败！";
}else{
    $db->query('set names utf8');  //解决乱码
    
    
    $filePath = "upload/".$_FILES["file"]["name"];
    require_once 'Classes/PHPExcel.php';
    /**对excel里的日期进行格式转化*/
    function GetData($val){
        $jd = GregorianToJD(1, 1, 1970);
        $gregorian = JDToGregorian($jd+intval($val)-25569);
        return $gregorian;/**显示格式为 “月/日/年” */
    }
    
    $PHPExcel = new PHPExcel();
    
    /**默认用excel2007读取excel，若格式不对，则用之前的版本进行读取*/
    $PHPReader = new PHPExcel_Reader_Excel2007();
    if(!$PHPReader->canRead($filePath)){
        $PHPReader = new PHPExcel_Reader_Excel5();
        if(!$PHPReader->canRead($filePath)){
            echo 'no Excel';
            return ;
        }
    }
    
    $PHPExcel = $PHPReader->load($filePath);
    /**读取excel文件中的第一个工作表*/
    $currentSheet = $PHPExcel->getSheet(0);
    /**取得最大的列号*/
    $allColumn = $currentSheet->getHighestColumn();
    /**取得一共有多少行*/
    $allRow = $currentSheet->getHighestRow();
    /**从第二行开始输出，因为excel表中第一行为列名*/
    $param=array('A'=>'','B'=>'','C'=>'');
    $count=0;
    for($currentRow = 2;$currentRow <= $allRow;$currentRow++){
        /**从第A列开始输出*/
        for($currentColumn= 'A';$currentColumn<= $allColumn; $currentColumn++){
            $val = $currentSheet->getCellByColumnAndRow(ord($currentColumn) - 65,$currentRow)->getValue();/**ord()将字符转为十进制数*/
                /**如果输出汉字有乱码，则需将输出内容用iconv函数进行编码转换，如下将gb2312编码转为utf-8编码输出*/
                //echo iconv('utf-8','gb2312', $val)."\t";
            $param[$currentColumn]=$val;
        }
        $query="insert into keywords values('',".$param['A'].",'".$param['B']."','".$param['C']."')";
        if($db->query($query)===true)
            $count++;
    }
    unlink ($filePath);
	$db->close();
    echo "成功过导入".$count."条记录！";
}
?>
</span>
<script type="text/javascript">
var i = 3;
var intervalid;
intervalid = setInterval("fun()", 1000);
function fun() {
    if (i == 0) {
 	   history.back()
       clearInterval(intervalid);
	}
    document.getElementById("mes").innerHTML = i;
    i--;
} 
</script>
<p>将在 <span id="mes">3</span> 秒钟后返回！</p> 
</body>